{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import pickle\n",
    "import seaborn\n",
    "\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>item_id</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>action_time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>11482147</td>\n",
       "      <td>492681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>12070750</td>\n",
       "      <td>457406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>12431632</td>\n",
       "      <td>527476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>13397746</td>\n",
       "      <td>531771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>13794253</td>\n",
       "      <td>510089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>14378544</td>\n",
       "      <td>535335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>1705634</td>\n",
       "      <td>535202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>6943823</td>\n",
       "      <td>478183</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:01</th>\n",
       "      <td>5902475</td>\n",
       "      <td>524378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:02</th>\n",
       "      <td>12646404</td>\n",
       "      <td>529724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:02</th>\n",
       "      <td>13156768</td>\n",
       "      <td>426867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:02</th>\n",
       "      <td>14367772</td>\n",
       "      <td>484321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:02</th>\n",
       "      <td>15967218</td>\n",
       "      <td>468533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:02</th>\n",
       "      <td>7500423</td>\n",
       "      <td>531150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>11227572</td>\n",
       "      <td>522855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>12431632</td>\n",
       "      <td>534450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>12799141</td>\n",
       "      <td>531289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>14380477</td>\n",
       "      <td>535477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>15894951</td>\n",
       "      <td>491934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>15905528</td>\n",
       "      <td>432274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>1904514</td>\n",
       "      <td>530486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>2415271</td>\n",
       "      <td>535363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>2472319</td>\n",
       "      <td>535334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>6088961</td>\n",
       "      <td>533833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>8350505</td>\n",
       "      <td>527149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:04</th>\n",
       "      <td>11996914</td>\n",
       "      <td>530796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:04</th>\n",
       "      <td>14378544</td>\n",
       "      <td>515907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:04</th>\n",
       "      <td>16401821</td>\n",
       "      <td>535084</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:04</th>\n",
       "      <td>7908369</td>\n",
       "      <td>503571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:04</th>\n",
       "      <td>8462794</td>\n",
       "      <td>500412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:55</th>\n",
       "      <td>14503435</td>\n",
       "      <td>556944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:55</th>\n",
       "      <td>14785354</td>\n",
       "      <td>557391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:55</th>\n",
       "      <td>6046417</td>\n",
       "      <td>549425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:55</th>\n",
       "      <td>7994897</td>\n",
       "      <td>542900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:55</th>\n",
       "      <td>8046141</td>\n",
       "      <td>548638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>13642170</td>\n",
       "      <td>557656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>14597382</td>\n",
       "      <td>529781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>15123124</td>\n",
       "      <td>542966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>1552565</td>\n",
       "      <td>540172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>16801260</td>\n",
       "      <td>557673</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>9526597</td>\n",
       "      <td>556855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>13050562</td>\n",
       "      <td>522664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>13375001</td>\n",
       "      <td>542997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>14597382</td>\n",
       "      <td>524113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>15488166</td>\n",
       "      <td>555820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>16243453</td>\n",
       "      <td>557432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>16487497</td>\n",
       "      <td>545043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>17026753</td>\n",
       "      <td>543007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:58</th>\n",
       "      <td>11283320</td>\n",
       "      <td>553331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:58</th>\n",
       "      <td>12982345</td>\n",
       "      <td>514928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:58</th>\n",
       "      <td>1469607</td>\n",
       "      <td>555989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:58</th>\n",
       "      <td>3063774</td>\n",
       "      <td>557764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:58</th>\n",
       "      <td>9121520</td>\n",
       "      <td>552734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>10383492</td>\n",
       "      <td>536548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>13006837</td>\n",
       "      <td>552829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>13992209</td>\n",
       "      <td>548120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>14597382</td>\n",
       "      <td>453373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>16699556</td>\n",
       "      <td>523378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>4496330</td>\n",
       "      <td>557706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>9391042</td>\n",
       "      <td>555820</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3272043 rows × 2 columns</p>\n",
       "</div>"
      ]
     },
     "output_type": "execute_result",
     "metadata": {}
    }
   ],
   "source": [
    "train = pd.read_pickle('../pkl/process.train.pkl')\n",
    "all_news = pd.read_pickle('../pkl/process.all_news.pkl')\n",
    "news = pd.read_pickle('../pkl/process.news.pkl')\n",
    "train[['user_id', 'item_id']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "m_data = pd.merge(train, all_news[['item_id','timestamp','date']], how='left', on='item_id')\n",
    "m_data = pd.DataFrame(data=m_data.values, columns=m_data.columns, index=train.index)\n",
    "# m_data.to_pickle('merge_data.pkl')\n",
    "# m_data['user_id' == '0365F7AE-5048-42B3-BB2C-8E637A380A3E']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f4371de2400>"
      ]
     },
     "execution_count": 4,
     "output_type": "execute_result",
     "metadata": {}
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYsAAAESCAYAAAAMifkAAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzsvXuYXGWVqP9WV1Xfb7l00kkg4eqKIIiIIoFwCSKKggIC\nyuWMMPNTzyAHUJmHOXNkOHh0fOYckYODDhNlQJAjOoIanSAgIOGO3BIgLJKQC+TWnXR3+lr3/ftj\n713pFF1du6qrurtgvc+TJ1Vfffvba1d377XX5Vsr5DgOhmEYhjEeNVMtgGEYhjH9MWVhGIZhFMSU\nhWEYhlEQUxaGYRhGQUxZGIZhGAUxZWEYhmEUJFJogoiEgH8FPgDEga8Cw8CduMpmO3CJqiZF5CLg\nSiANLFfV20QkAtwOLAJSwKWquklEjgR+DGSA1ap6uXe+a4DPe+M3qOpKEWkF7gbagAHgQlXtK9N3\nYBiGYRQgiGXxWaBVVY8H/hr4PnAD8ENVPQnYAFwmIo3At4BlwCnA1SLSDlwI9KrqUuC7wPe8dW8C\nrvDG20XkdBE5ADgfWAKcCdzoKaurgEe8ufcB10780g3DMIygBFEWhwLPAqjqRlwL4SRghff5CuA0\n4FjgWVUdVNUY8DhwAnAq7g0e4CFgiYhEgQNV9YWcNU4BVqpqWlV3AZuAw3PWWAF8vKSrNQzDMEoi\niLJYA5wuIjUiIsBBwAGqmvQ+7wLmAXOB7lHHdeeOq6oDOEAn0DNqbr41xhrv8o43DMMwJomCykJV\n78e1LP4M/DdgLZAcNSWU59Dxxp2cz/PNHUu+fHMNwzCMClEwwA2gqtf5r0VkPfC2iNSpahxYAGwF\ntuFaAT4LgKe88U5gjRfsDuEGxWflzPXXWJxnvBM3uL3Aez8ujuM4oZDpFcMwjCLIe9MMkg11JHCl\nqv61iHwSeB7oxc1Y+jlwLuBbHz/xMpcyuEHqK3EzmM4DHgTOwg1Up0VkrYgsUdUngXOAm4F1wNdF\n5DpgDjBfVV8TkQdxA9/fGXW+8a84FKK7e6DQtGlHR0dLVcoN1St7tcoN1St7tcoN1St7ELk7Olry\nfhbEslgDhETkGWAEuAg3NfZnIvJlYDNwh6cArgUewFUW16vqgIjcA5wmIquAGPAlb92rgVu9bKdn\nVPVhABFZDqzy1viqN/dm4C4ReQxXUV0cQG7DMAyjTITexSXKnXer9p+uVKvs1So3VK/s1So3VK/s\nAS2LvG4o28FtGIZhFMSUhWEYhlEQUxaGYRhGQUxZGIZhGAUxZWEYhmEUxJSFYRjGJPHnPz/MypW/\nZ9WqR8uy3sjICOeddxYA11//DyQSCbZs2cQXv3gOv/71L3nxxef5whfO4dFH/zThc5myMAzDmAS2\nb9/Ggw/+kU996jMsXXpyWdZ0tz642a7XX/8damtree21V1my5ATOPfd8Xn75Rc4993xOPvnUCZ8r\nULkPwzAMY2L84Af/zGuvvcqJJ36Uq666hgMPPIhf/eoXhMNh1q1TLrnkUp555inWrVMuv/xKTjjh\nJP7850f4xS/uIhKJsHjxYVx++ZUMDw/xD//wdySTSY444oPZ9c877yx+9KOfcOed/04sFqOzcz5/\n+MPviEQizJo1mwsuOHtC8puyMAzjPccvH17Pc693lXRsOBwinX7nZuaPLJ7D+csOyXvcF794Cffe\n+ysOOujg7Nj69W9w992/5sUXn+fb376OX/3qd7zyymp+/etf8uEPf5Q77vgp//ZvtxOJRLjuur9n\nzZqXWb9+HQcddAhXXHE1f/rTgzz00APeaiFaWlq5+OIvsXHjBs477wsMDPTT3j6DZcsm3tXBlIVh\nGMYkkVsx45BD3pd98t9//4XU1dUxY8ZMhoYG2bhxA11dO/j617+G4zgMDQ2xc+cONm16kw996MMA\nHH30h0evXlHZTVkYhvGe4/xlh4xrBYxHOct9hMPhMV87jkM0WovIYXz/+zfvc8zq1S8RCrnh5kwm\nUxY5/HOOhwW4DcMwJoGamhrS6XTg+QsXLmTz5o309fUB8NOf3squXbtYuHARr7/+GgDPP/+Xssn3\n55fH7/xgysIwDGMSWLToQNatUwYHBwPNr6ur54orvs43v/nf+Nu//RsGBvqZPXs2n/zkZ3j11TVc\nddXf8tZbm6mp8Wv/Tax/T1fPyLifW9XZaUa1VrSE6pW9WuWG6pW9WuWG6pW9kNw/+6PyjYuPsaqz\nhmEYRn7iidS4n5uyMAzDMIgnxw+WB2mr2gT8DJgB1AI3AK8Bd+Iqm+3AJaqaFJGLcFuppoHlqnqb\n13f7dmARkAIuVdVNXrvWH+N2xFutqpd757sGt2VrBrhBVVd6rVrvxm3ROgBcqKp9xXwRhmEYRn7K\nYVl8CXhdVZfh9tL+v7gK419U9SRgA3CZiDQC3wKWAacAV4tIO3Ah0KuqS4HvAt/z1r0JuMIbbxeR\n00XkANxe20uAM4EbvbarV+H27l4K3AdcG+zyDcMwjCDEkuNnagVRFruAWd7rmUA3cBLwO29sBXAa\ncCzwrKoOqmoMeBw4ATgV9wYP8BCwRESiwIGq+kLOGqcAK1U1raq7gE3A4TlrrAAmvh3RMAzDyBJP\nTFBZqOo9wCIRWQc8ClwDNKlq0pvSBcwD5uIqEp/u3HFVdXC3GXYCPaPm5ltjrPEu73jDMAyjTMQK\nKIsgMYuLgM2q+ikROQL495wp+VKtxht3cj7PN3csZRY4mbijoyXo1GlFtcoN1St7tcoN1St7tcoN\n1Sv7eHIn0xMMcAPHA38EUNU1IjIPGBKROlWNAwuArcA2XCvAZwHwlDfeCazxgt0h3KD4rJy5/hqL\n84x34ga3F3jvC/JuzIWezlSr7NUqN1Sv7NUqN1Sv7IXkHolNPMC9HvgYgIgswr1hP4ibsQRwLnA/\n8CxwjIi0ikgzbpB6lTf3PG/uWbiB6jSwVkSWeOPneGs8ApwhIhERmQ/MV9XXvDXOzzmfYRiGUQYy\nGYdEauKWxa3AbSLyKBAGvgIo8DMR+TKwGbhDVdMici3wAG7a6/WqOiAi9wCnicgqIIabXQVwNXCr\nl+30jKo+DCAiy3GVTAb4qjf3ZuAuEXkM6AUuDiC3YRiGEYB4gUwosHIf045qNXGhemWvVrmhemWv\nVrmhemUfT+7egTjfuOUJVnz/s1buwzAMwxibIJaFKQvDMIz3OIX2WIApC8MwjPc8sQKlPsCUhWEY\nxnsec0MZhmEYBSm0extMWRiGYbznsZiFYRiGUZBCFWfBlIVhGMZ7HrMsDMMwjIJYgNswDMMoiAW4\nDcMwjIKYG8owDMMoiAW4DcMwjIKYZWEYhmEUJJ5IFWxBasrCMAzjPU4smaa2NjzuHFMWhmEY73Hi\niTT10fGVRcFOeSJyGXAJ4OD2z/4wcBhwJ66y2Q5coqpJEbkIuBJIA8tV9Tav7/btwCIgBVyqqptE\n5Ejgx7gd8Var6uXe+a7BbdmaAW5Q1ZUi0grcDbThtnW9UFX7ivkyDMMwjLGJJdPUTdSyUNXbVPUU\nVV0G/CNwB3AD8ENVPQnYAFwmIo3At4BlwCnA1SLSDlwI9KrqUuC7wPe8pW8CrvDG20XkdBE5ALfX\n9hLgTOBGr+3qVbi9u5cC9wHXFvE9GIZhGOMQxLIo1g11HfBt4GRghTe2AjgNOBZ4VlUHVTUGPA6c\nAJyKe4MHeAhYIiJR4EBVfSFnjVOAlaqaVtVdwCbg8Jw1VgAfL1JuwzAMYwwcxyGeKINl4SMixwBb\nVLULaFLVpPdRFzAPmAt0jzqkO3dcVR1cd1Yn0DNqbr41xhrv8o43DMMwJkgilcGBgsqiYMxiFH+D\nG3vIJV/G1XjjTs7n+eaOpcwKZXhl6ehoCTp1WlGtckP1yl6tckP1yl6tckP1yj6W3H0DcQDamuvH\nPbYYZXEy8DXv9YCI1KlqHFgAbAW24VoBPguAp7zxTmCNF+wO4QbFZ+XM9ddYnGe8Eze4vcB7X5Du\n7oHgVzdN6OhoqUq5oXplr1a5oXplr1a5oXplzyd3V9+I+8LJjHt8IDeUiMwDBlTVb9T6EHCu9/pc\n4H7gWeAYEWkVkWbcIPUq4EHgPG/uWbiB6jSwVkSWeOPneGs8ApwhIhERmQ/MV9XXvDXOzzmfYRiG\nMUH83dv10fFth6CWxTzcWIHP9cDPROQrwGbgDlVNi8i1wAO4aa/Xq+qAiNwDnCYiq4AY8CVvjauB\nW71sp2dU9WEAEVmOq2QywFe9uTcDd4nIY0AvcHFAuQ3DMIxx8JVFoZhFyHGcyZBnKnDeTaZiNVCt\nsler3FC9sler3FC9sueT+5WNu7nxnpc5+8SDuOyzR+SNCdsObsMwjPcwe91QVu7DMAzDyEMsoBvK\nlIVhGNOON7f184NfvsxwLFV4sjEh/Jaq9aYsDMOoNp7XLta8uZv1W/dMtSjverIBbnNDGYZRbYzE\nXYtiOJ4sMNOYKL4byiwLwzCqjmFfWZgbquL4biiLWRiGUXX4T7tDpiwqTszcUIZhVCu+ZTFiyqLi\n7A1wj79H25SFYRjTDj9mMRSzmEWlsQC3YRhVy4jFLCaNWML9jutqx1cHpiwMw5h27M2GMmVRaeLJ\nNNFIDeEaUxaGYVQRGcchFvcD3OaGqjSxRLqgCwpMWRiGMc2IxdP45U3NDVV54sl0wT0WYMrCMIxp\nxsgo15Mpi8oTpP82mLIwDGOaMVpZjMRTZN69bRSmBbFEumDFWTBlYRjGNGMksVdZOEDMgtwVI5XO\nkM44gSyLQJ3yROQi4BogCVwHrAHuxFU224FLVDXpzbsSSAPLVfU2r+/27cAiIAVcqqqbRORI4Me4\nHfFWq+rl3rmuAT7vjd+gqitFpBW4G2jD7cN9oar2Bfo2DMOoKkZylMNQLEVjfXSKpHl3E3T3NgSw\nLERkJq6CWAJ8BvgccAPwQ1U9CdgAXCYijcC3gGXAKcDVItIOXAj0qupS4LvA97ylbwKu8MbbReR0\nETkAt9f2EuBM4Eav7epVuL27lwL3AdcW/hoMw6hG/HTZSNi9PVnconLEAxYRhGCWxceBB1V1GBgG\nviIibwJf8T5fAXwTeAN4VlUHAUTkceAE4FTgDm/uQ8BPRSQKHKiqL4xa4zRgPrBSVdPALhHZBBzu\nrXHpqLm/DyC3YRhVyIiXNjurrZ6dPcMMW/psxYhliwgWVgVBlMUBQJOI/BZoB/4n0Kiq/k+wC5gH\nzAW6Rx3XnTuuqo6IOEAn0DNqrr/Grpw1xlq7yzveMIx3Ib4banZrHTt7hq2YYAUJ2lIVgimLEDAT\nOBtXcTzijY3+PN9x+cadgGuM5SbL21A8l46OlqBTpxXVKjdUr+zVKjdUr+z55A557qf9Olt5dVMv\nNdHItLvG6SZPUHLl3tYXA2Bme0PBawqiLHYCT6pqBnhTRAaApIjUqWocWABsBbbhWgE+C4CnvPFO\nYI0X7A7hBsVn5cz111icZ7wTN7i9wHtfkO7ugSDTphUdHS1VKTdUr+zVKjdUr+zjyb2rdxiARs+P\n3rVrcFpd47vpO9/pvU8l03R3D4yrMIKkzj4ALBORkIjMAppxYw+f9z4/F7gfeBY4RkRaRaQZN0i9\nCngQOM+bexZuoDoNrBWRJd74Od4ajwBniEhEROYD81X1NW+N83POZxjGu5CsG6qtHrCSH5WkrAFu\nVd0mIv8BPI3rProc+Atwp4h8GdgM3KGqaRG5Fle5ZIDrVXVARO4BThORVUAM+JK39NXArV620zOq\n+jCAiCzHVTIZ4Kve3JuBu0TkMaAXuLjglRmGUZX4PSx8ZWHZUJUjFrBLHgTcZ6Gqy4HlOcOfGGPe\nvcC9OWMZ4LIx5q4FThxj/BbglpyxIdyYiWEY73JGEmk3UNriKQvblFcxiglw2w5uwzCmFSPxFPV1\nYZoa3GdZc0NVjmzjI6sNZRhGtTEST9FQF6EuGiZcEzI3VAUpxg1lysIwjGmFryxCoRCN9RFTFhXE\n3FCGYVQljuMwEk/T4O0obqyL2A7uChIzN5RhGNVIPJkm4zg01HnKoj7KUCyFY2XKK0I86afOFs51\nMmVhGMa0wa8L1VDnPuk21UdIZxwSqcxUivWuJe6Vg7e2qoZhVBV+mmxj1rJw/7e4RWWIJdOEa0JE\nwoWrKJmyMAxj2uDv3h7thgIsblEh4ok0ddEwoZApC8MwqohYjrJoqvf3WphlUQliAftvgykLwzCm\nEcO5lkWduaEqSTyZDlQXCkxZGIYxjRjJF7OImxuqEvhuqCCYsjAMY9qwNxvKd0O5MQtzQ5WfjJdl\nZpaFYRhVx143lHsDa7BsqIrh77Ewy8IwjKojNxuqyZRFxShm9zaYsjAMYxrxjtTZbIDbYhblZu/u\n7WDKouAebxE5CfgV8ApuS9TVwP8G7sRVNtuBS1Q1KSIXAVcCaWC5qt7mtVK9HVgEpIBLVXWTiBwJ\n/Bi3ydFqVb3cO981uF34MsANqrpSRFqBu4E23NaqF6pqX6ArNAyjasi3z8JiFuUnW548GqitUWDL\n4lFVXaaqp6jqlcANwA9V9SRgA3CZiDQC3wKWAacAV4tIO3Ah0KuqS4HvAt/z1rwJuMIbbxeR00Xk\nANz2qUuAM4EbvU56V+G2Y10K3AdcG1BuwzCqiJGcmEXWsrAGSGUn5pf6KLMbKnd738nACu/1CuA0\n4FjgWVUdVNUY8DhwAnAq7g0e3N7dS0QkChyoqi/krHEKsFJV06q6C9gEHJ6zxgrg4wHlNgyjihiJ\np70+Fu6tqaYmRENd2NxQFaDsbiiPw0TkN8BMXKuiUVX9n14XMA+YC3SPOqY7d1xVHRFxgE6gZ9Rc\nf41dOWuMtXaXd7xhGO8y3F4W+968Guui5oaqANkAdxmzodYB16vq54AvAT9lXyWTr6jIeONOzuf5\n5o4lX+EiJoZhVCXDXuOj0TTVR8wNVQGyjY/KZVmo6jbcADeq+qaI7ACOEZE6VY0DC4CtwDZcK8Bn\nAfCUN94JrPGC3SHcoPisnLn+GovzjHfiBrcXeO8L0tHREmTatKNa5Ybqlb1a5YbqlT1XbsdxiCVS\nLOho3ueztpZ6tnQNMmNmE5Hw9EjgfDd85xFPKXfMbg50PUGyoS4E5qnq90WkE9cl9O+4GUs/B84F\n7geeBX7iZS5lcIPUV+JmMJ0HPAichRuoTovIWhFZoqpPAucAN+NaMV8XkeuAOcB8VX1NRB7EDXx/\nZ9T5CtLdPRBk2rSio6OlKuWG6pW9WuWG6pV9LLkTyTSptEMkHNrns6hXPnvz2720NtZOqpxj8W75\nznf3DAOQGElkx8dTGkFiFr8D7haRzwJR4CvAy8DPROTLwGbgDk8BXAs8gKssrlfVARG5BzhNRFYB\nMVxXFsDVwK1ettMzqvowgIgsB1Z5a3zVm3szcJeIPAb0AhcHkNswjCoiN23Wx68PNRJLTQtl8W4h\nu4O7jG6oQVyLIJdPjDH3XuDenLEMcNkYc9cCJ44xfgtwS87YEHB2IVkNw6he9jY+yg1wW5nySlCJ\nALdhGEbFyS0i6NNklWcrQrEBblMWhmFMC/K7ofxueWZZlJNY1g1V3h3chmEYFaVQzMLcUOUla1mY\nG8owjGoit/GRz97Ks+aGKifxRIoQEI0GUwOmLAzDmBaYG2pyiSXT1NaGqQkF2+dsysIwjIJs2TnA\nf/+3p9nh5eZXgmzjo1rLhpoM4ol0YBcUmLIwDCMAr27sYUfPMGs391bsHNlsqPp82VCmLMpJLJkO\nvMcCTFkYhhGAPUMJAPq9/ytBoQC3xSzKi1kWhmGUnf7hxD7/V4J8yiIaCRON1Jgbqow4jkPcLAvD\nMMrNwCRYFsN5sqHAtS5GTFmUjWQqg+MEL/UBpiwMwwjAniHXBVRpN1Q0UjNmZdnGughD5oYqG/6G\nPHNDGYZRVrJuqAori1wXlE9TfZTheIqM41Ts/O8lsv23zbIwDKNcZDIOA5MRs0ik8yqLxvoIjrP3\nJmdMjL27t4M2SzVlYRhGAQZHkvgP9CPxNMlUZW7YI/HUOyrO+uwt+WGuqHIQK7I8OZiyMAyjALmu\np/6h8t+wU+kMyVSG+jxF7ZrqbBd3OTE3lGEYZSfX9VQJV9R4mVAweq+FKYtyECuyiCAE65SHiNQD\nrwA3AA8Dd+Iqmu3AJaqaFJGLcNuopoHlqnqb13P7dmARkAIuVdVNInIk8GPcbnirVfVy7zzX4LZr\nzQA3qOpKr03r3bjtWQeAC1W1L/AVGoYxIXzLYnZbPbv2xLIb9MpJvj0WPlZ5trzEk+73WAnL4lvA\nbu/1DcAPVfUkYANwmYg0enOWAacAV4tIO3Ah0KuqS4HvAt/z1rgJuMIbbxeR00XkANw+20uAM4Eb\nvZarV+H27V4K3AdcG/jqDMOYML6y2K+jGdi756KcBFUW1gCpPBTb+AgCKAsREWAx8AcgBJwErPA+\nXgGcBhwLPKuqg6oaAx4HTgBOxb3BAzwELBGRKHCgqr6Qs8YpwEpVTavqLmATcHjOGiuAjwe+OsMw\nJswez+2035wmoDJuKH/DXUOeAHeTVZ4tK9kAd5n3WXwf+DquogBoUlVfvXcB84C5QPeoY7pzx1XV\nARygE+gZNTffGmONd3nHG4YxSeRaFpVwQw17RQTzxiys8mxZiRfZfxsKKAsRuQR4UlU355mSrxD6\neONOzuf55o4lW7DC64ZhlA0/+8lXFpXYmBfUDWUlP8pDrIRsqEIB7k8DB4rImcACIAEMikidqsa9\nsa3ANlwrwGcB8JQ33gms8YLdIdyg+Kycuf4ai/OMd+IGtxd47wPR0dESdOq0olrlhuqVvVrlhsrL\nPpxIURsNc9ihHQDEkpmynHP0GuHaLgDmzmkZc20n4t7U0kyPn9V0kKEUfLlDXkmVeXNbA1/LuMpC\nVb/gvxaR63DjCEtwM5Z+DpwL3A88C/zEy1zKeHOuxM1gOg94EDgLN1CdFpG1IrJEVZ8EzgFuBtYB\nX/fOMweYr6qviciDuIHv74w6XyC6uweCTp02dHS0VKXcUL2yV6vcMDmy9+yJ0doYpa93mMa6CLv7\nRiZ8zly5u3cPAZCMJ8dcO+ZZHj17Jn7uiVKtvy+j5d7THwNgeDBGd82+c/IRfK/3XhfQPwJ3isiX\ngc3AHZ4CuBZ4AFdZXK+qAyJyD3CaiKwCYsCXvDWuBm71sp2eUdWHAURkObDKW+Or3tybgbtE5DGg\nF7i4CJkNw5gAjuOW+th/jnsTaW2qrWzqbJ5NefVe+08LcJeHWAnZUIGVhar+z1FvPzHG5/cC9+aM\nZYDLxpi7FjhxjPFbgFtyxoaAs4PKaRhG+RiOp0ilHdqaagFXWezsGSadyRCuKd+e3r0xi7FvXqFQ\niMZ6qzxbLuJeNlStVZ01DKMc+MHs1qao938tDjAwXN6bdqFsKP8zsyzKQyyRJhIeuxx8PkxZGIaR\nl73KwrMsGqP7jJeLQtlQ4GZEWR/u8hBPpotyQYEpC8MwxsGPT7Q27nVDQfk35o3EU4RrQkQj+W9J\nTfURkqlMxarevpeIJ1JF7bEAUxaGYYyD725qbcpRFhWwLBrqIoRC+bdSNXi7uG1j3sSJJcyyMAyj\njPiWhR/gbmv0lUW5YxapceMV4FoWMHUlPxLJNL96ZD09XtppNRNPpovakAemLAzDGAffgmjJdUOV\n2bKIxfN3yfPxlclUKYuX1u9i5TNb+ONTm6bk/OUilc6QSjvmhjIMo3zkBrhbKhCzSGcyxJPpvGmz\nPlPdLW+3Z1Fs7R6akvOXCz9t1txQhmGUjf7hBOGaUNYFtNcNVT5lMeKlzRayLLKVZ6coI6qnPw7A\n9t2DU3L+clFKlzwwZWEYxjj0DyVobarNBp7rasPURcNlVhaF02Zh6rvl+bGKbVVuWZTSJQ9MWRiG\nMQ79w4ls2qxPa1M02+OiHBSvLKbWDTU4kmRwpHp3kvtuKLMsDMMoC7FEikQyk41X+LQ21jI4nCTj\nOGU5T1Bl0TTFqbO+GwpgZ8/wlMhQDmIl9LIAUxaGYeQhG9z2dm37tDbVks44ZXMH+TGIQqmzU5kN\nFU+m97EmdvZWr7LY21K1mDqypiwMw8iDv5fiHZaF975c1WcLFRH02duHe/KVhR+vmNVaD0BX78ik\ny1AuYkn3+zM3lGEYZWFPTtqsT2uZM6KCZkNNZcyiZ8B1Qb1/0QwAdlaxsohbgNswjHLi76XIZ1mU\nT1kEc0OFa2qoqw1PScyiZ49rWRyyXxuRcE1VxywsddYwjLKSuyHPp9zFBIMGuMEt+TEVMQs/E2p2\nWz3zZjeys3cEp0wB/skmVmI2VMGfjog0ALcDc4E64H8BLwN34iqb7cAlqpoUkYtw26mmgeWqepvX\ne/t2YBGQAi5V1U0iciTwY9yueKtV9XLvfNfgtm3NADeo6kqvXevduG1aB4ALVbWvqCs1DKMofGXQ\nlps6W+Yy5b6yqA+gLBrrouzun3wXkO+Gmtlaz/zZzby1c5CBkeQ70oqrgUq6oc4EnlPVk4ELgBuB\nG4B/UdWTgA3AZSLSCHwLWAacAlwtIu3AhUCvqi4Fvgt8z1v3JuAKb7xdRE4XkQNw+20v8c57o9d6\n9Src/t1LgfuAa4u6SsMwiiZbF6rCbqig2VDgxi1G4mkymcl9qvcD3DNb6pg3uwmo3iB3xSwLVf3l\nqLcLgbeAk4CveGMrgG8CbwDPquoggIg8DpwAnArc4c19CPipiESBA1X1hVFrnAbMB1aqahrYJSKb\ngMO9NS4dNff3RV2lYRhF0z+UIBSCloZ9U2fbyh6z8APchW9eTaMyoppz5Koku/vjtDRGqY2Gmd/R\nDLh7LQ5Z0DZpMpSLige4ReQJ4C7gaqBJVf2UhC5gHq6bqnvUId2546rqAA7QCfSMmptvjbHGu7zj\nDcOoIP1DCVoaotTU7NtjoqEuQiQcKmvMoiYUCrRJbCoyohzHobc/xswWN212/izXsqjWjKhSA9yB\nd2Wo6vFenOHnwOjfnnzdSsYbdwKuMZYyy98dJYeOjpagU6cV1So3VK/s1So3VE72gZEkc2Y0jrl+\ne3MdQ7HUhM7tH5tIZ2isjzBnTmvBY2bNaASgtqF20n5mewbjJFIZ5nU00dHRghNxb7J7hpNV93vT\n0dFCxnvXiA6tAAAgAElEQVS93/x2aouwLoIEuI8GulT1bVVdLSJhYEBE6lQ1DiwAtgLbcK0AnwXA\nU954J7DGC3aHcIPis3Lm+msszjPeiRvcXuC9L0h390CQadOKjo6WqpQbqlf2apUbKid7MpVmOJai\nsS485vpNDVG27Rqiq6t/3O52+Rgt98BQgvrasc+TS40Xq9i6o5/2+uJ2IJfK5h2uXM11Ebq7B5g9\nq5lopIYt2/ur6vfG/84HhhLUhEL09Q6942c3nvIL4oY6EfgGgIjMBZpxYw+f9z4/F7gfeBY4RkRa\nRaQZN0i9CngQOM+bexZuoDoNrBWRJd74Od4ajwBniEhEROYD81X1NW+N83POZxhGhci3e9unramW\nZCqTrTM0EfyWqkFomILKs9ngtrd7u6YmxJz2Bnb2Dldl+mws4XbJK1bJB/kJ/StuUPoxoB74r8Dz\nwJ0i8mVgM3CHqqZF5FrgAdy01+tVdUBE7gFOE5FVQAz4krfu1cCtXrbTM6r6MICILMdVMhngq97c\nm4G7PBl6gYuLukrDMIoiuyEvT2ro6F3cQW/0Y5FxHGKJwl3yfJqmoAHS7qyyqMuOzZnRwNZdQwwM\nJ/Mq1OlKPJkquvERBMuGigEXjfHRJ8aYey9wb85YBrhsjLlrca2W3PFbgFtyxoaAswvJahhGechX\n6sOnpcnbazGcYO7MxpLPE/MzoQLevBq9yrMjk2pZuHss/LpQQPaad/YOV5+ySKSz32Mx2A5uwzDe\nwd6Ks3ncUGWqD5XdvR0w/uDvxZjMkh89A/u6ocC1LAB29lRfRlQsmS46EwpMWRiGMQb5Sn34lGtj\nXjGlPmDffRaTxe7+GOGaUHZ/CcDcGXsti2oik3FIJDNF77EAUxaGYYyBrwTaCiiLiZYpL2b3Nux1\nQ03mPoue/jgzWur22W8y17csqmyvRald8sCUhWEYY5Cv4qzP3mKCE7tpF2tZNNZPrhsqlc7QNxhn\nZkvdPuPtLXXURmroqjLLwlcWpQS4TVkYhvEOsnWhGscOhPqxjIFJdkPVRmqIhEOTljrbNxjHcWBm\nW/0+4zWhEHNmNFRd9dl4iS1VwZSFYRhj0D+cpKk+QiQ89i2iuSFKKAR7JljyI2iXPJ9QKERjfXTS\n3FBjZUL5zJnRSDyRLluNrMkgVmKpDzBlYRjGGPQPJcZNCa2pCdHSWDvhG2WxMQt/7mS5oUZXm82l\nGuMW5oYyDKNspNIZBgP0amgtg7Lwn3SL2djXVB9hJJ6aFPfP7v53ps36ZPdaVFHXvJi5oQzDKBcD\nw+OX+vBpa4oSS6RJJEsv+eFbFg21RVgW9VHSGSf7lFxJxnND+ZZFV181WhbF77o3ZWEYxj4MFMiE\n8mkpQ3vVYgPcMLpMeeVdUT1jlPrwmTOjGi0L9zszy8IwjAlTaEOez976UKUHm/2yHdNVWezuj1Nf\nGx5TvvbmWmqjNdUVs0hYzMIwjDKRrQuVJ23Wpxwd80biKUJAfcBsKJjcYoI9/TFmtdaPWaE1FAox\np72RripKn7VNeYZhlI1CG/J8WsvghhqOp6mvC1NTRLnsxjp/F3dlLYuReIrheIoZY7igfObObCCe\nTNM3WB3psxbgNgyjbAR1Q7WUoZhgMb0sfBonqT5Uz0D+4LaPXyOqWnZymxvKMIyyka0LVSB1tlxu\nqGKVRdMklfwYb4+FT7XttYiZG8owjHIROMA9QTeU4ziMJEqwLOr8AHdlYxa5HfLGYnRfi2oga1mU\n4IYK9FMSkX8GTgDCwPeA54A7cZXNduASVU2KyEXAlUAaWK6qt3l9t28HFgEp4FJV3SQiRwI/xu2I\nt1pVL/fOdQ1uy9YMcIOqrhSRVuBuoA23D/eFqtpX9NUahlGQ/uEk9bVhagvcUPy6UaVaFvFkGscp\nbvc2jK48W1nLYvc4eyx8/L4WXVXS16KiAW4RORk4TFWXAJ8CbgJuAP5FVU8CNgCXiUgj8C1gGXAK\ncLWItAMXAr2quhT4Lq6ywVvnCm+8XUROF5EDcHttLwHOBG702q5ehdu7eylwH3Bt0VdqGEYgCpX6\n8ImEa2iqj5RceXYkXpr/fLIqz463x8KnramWutpw1VgWfoC70IPAWARxQ/0ZOM973Qc0AScBv/PG\nVgCnAccCz6rqoNeK9XFca+RU3Bs8wEPAEhGJAgeq6gs5a5wCrFTVtKruAjYBh+essQL4eNFXahhG\nQTKO4/aVLhCv8GltKr3kRyl1oWBUA6RJckPNaMlvWYRCIea2N9DVO0KmCtJn44k0ddHiss98CioL\nVXVU1bex/hr4A9Ckqv5PqguYB8wFukcd2p07rqoO4ACdQM+oufnWGGu8yzveMIwyMziSJOM4gftK\ntzbWMjiSJJXOFH2uUnZvA9TXRQgxCdlQ/XHammqJRsa/Tc6Z2UgilWFPFaTPltpSFQLGLABE5LPA\nZcAngPWjPsqnosYbd3I+zzd3rJ9SYJXY0dESdOq0olrlhuqVvVrlhvLKPry9H4C5s5oCrdsxsxF9\nq4/ahlpmtTUUda5aL/Ywe2awc42msSFKPJWp2M8tk3HoGYhz4PzWMc8xeuzABW385fUu4pnp/3uU\nTGVoqo+WJGfQAPfpwN8Dp6vqgIgMiEidqsaBBcBWYBuuFeCzAHjKG+8E1njB7hBuUHxWzlx/jcV5\nxjtxg9sLvPcF6e4eCDJtWtHR0VKVckP1yl6tckP5Zd/0di8A0Zpgfz913lP3xi29ZDqDP+l3dLSw\no8tdP5NKF30NDbVhBoYSFfu57RlKkEpnaG2MvuMcud95s7f7XDfuorMtf3xjqunoaGEk7vYpyfe9\njadEggS4W4F/Bj6jqnu84YeAc73X5wL3A88Cx4hIq4g04wapVwEPsjfmcRZuoDoNrBWRJd74Od4a\njwBniEhEROYD81X1NW+N83POZxhGmfHTYPP13s7FLwkyUEL6bKkxC4Cm+mhFy3348YrxMqF8/I15\n032vheM4xBKVdUNdgGsF/NLLTHKAvwJ+KiJfATYDd6hqWkSuBR7ATXu93rNC7gFOE5FVQAz4krfu\n1cCt3prPqOrDACKyHFfJZICvenNvBu4SkceAXuDikq7WMIxx8YsCBo5ZePP2lBDkLjVmAW5GVCKZ\nIZXO5O3mNxF27ym8Ic+nWvpaJFIZHKe0PRYQQFmo6nJg+RgffWKMufcC9+aMZXBjHblz1wInjjF+\nC3BLztgQcHYhWQ3DmBh7e28XpyxK2ZhXbEvV0YyuPBtUsRWDX+pjvA15Pq2NUeprw9O+r0XM+75L\ntSxsB7dhGFmypT6KtCxKSZ/191mUYllUuvJs1g3VVlhZhEIh5s5onPbps75yLtWyMGVhGEaWoBVn\nfdomUExwQm6oClee3R2gLtRo5sxoIJnK0OdZJNORbMVZsywMw5goe4YSRCM1gXdV7+2WV/wT/kRj\nFlC5vRY9/XEi4VD2+goxd6ZXUHAaxy3MDWUYRtkYGE7Q2lg7ZrOfsaiLhqmrDU/Qsij+5jUZbqiZ\nLfWBdzpXQ0aUuaEMwygLjuMErgs1mrbG0kp+DMdT1EXDhGuKvw01VLC1ajKVYc9QYtyaULns7Wsx\nfZVFtv92bfGWHJiyMAzDYySeIpV2CrZTzaW1qZaB4WTRwV23l0VpT7lNFaw82zsYPBPKZ47vhprG\nBQVLLdzoY8rCMAxgVO/tIi2L1qZaMo7D0EhxLqGReLqkeAXsmzpbbnr2FO5jkUtLQ5SGusi0dkNl\nLQtzQxmGMRGCNj3KpbWEvhaO4zAST5W0exv27vquRMxid4DS5LmEQiHmzJje1WctwG0YRlnwM5pK\nsSygOGURT6ZJZ5ySLYusG6oC2VBBem+PxdwZDaTSmewejelG1g1lloVhGBOh2A15PtmSH0Xs4vbd\nR9PSDRWgnepYTPeMqL0BblMWhmFMgKwbKmCpD5/W7Ma84C4hv3FRqQHuSLiG2mhNZd1QATfk+fh7\nLaZrRlQ2ddaUhWEYE6HY3ds+/vxiKs9O1LIA1xVVkWyo/jiNdZGiZctaFtN0Y17Mc0NZgNswjAlR\ncoC7hMqzfubURJRFY12k7MrCcRx29ceKdkGBW/IDpq9l4buhzLIwDGNC9A8lCNeEsvGAoLSWUB+q\nHJZFY32EkXiqrNlHI/EU8US6qEwon+aGKI11kWm718J3Q9WaZWEYxkTYM5SgpTEauMSFT0NdmEi4\npihl4ccaSk2dBdcN5bA3JbQc9PSXlgkFXvXZmQ10942QyUy/9NlYIkUkXFNy/w9TFoZhAG7MopTe\nEKFQiLamaJExi4m7oRqyey3KpyxK2WMxmrkzGkmlnWmZPjsST5fsgoLgPbg/APwGuFFVfyQi+wF3\n4iqb7cAlqpoUkYuAK4E0sFxVb/P6bt8OLAJSwKWquklEjgR+jNsRb7WqXu6d6xrg8974Daq60mvt\nejfQhtuH+0JV7Sv5qg3D2Id4Ik0imSm5kVBLYy1vdw/hOE6gIoRDI+UIcJc/fbbUtFkfP26xs3eE\n2e0NZZOrHMQSqZKD2xCsB3cjblvTh0YN3wD8UFVPAjYAl3nzvgUsA04BrhaRduBCoFdVlwLfBb7n\nrXETcIU33i4ip4vIAbi9tpcAZwI3em1Xr8Lt3b0UuA+4tuQrNgzjHfh7JNqKTJv1aW2qJZXOZDd+\nFWK4DG6ovXstxk6fTaYyPL56O9++4zl+8vvXAq1Z6oY8n717LaZf3CIWT1XcsogBn2LfG/TJwFe8\n1yuAbwJvAM+q6iCAiDwOnACcCtzhzX0It3d3FDhQVV8YtcZpwHxgpaqmgV0isgk43Fvj0lFzf1/M\nRRqGMT7ZdqolWhaj26sGCZAPTXCfBUCjt4s71w3VP5TgkRe38sgLb2d3pW/cPsBxH+jk8ANmjrvm\nRN1Q2YKCPdMvI2oknqajvYKWhapmVDW3/VOTqvrqvAuYB8wFukfN6c4dV1UHcIBOoGfU3HxrjDXe\n5R1vGEaZKHVDnk9bkSU/fNdRfTncUF6A++3uQW77z7V880dP8tvHN5JMO3zy2IVcce4RAPzHoxtw\nCmRO9eyJEQLam0uPWQDoW73EE8GsrMkglc6QSmcm5IYq/Se1l3wOyvHGnZzP880dS5kFTtXo6GgJ\nOnVaUa1yQ/XKXq1yQ3lkz6zfDcB+81pLWm/+HO+YSDjQ8b7raOGCGUQjpeXZzJszCMD6bf28tH43\nL61znyfnzW7irKUHcepHFmZjIi+u383jL29j3fZBjv/g/Lxr9g0nmdlWz7zOtnHPne8aO4DjjpjH\nU2u2c9OvV/OPf/MxWkpUwOVk0N9w2VxX8u9LqcpiQETqPItjAbAV2IZrBfgsAJ7yxjuBNV6wO4Qb\nFJ+VM9dfY3Ge8U7c4PYC731BursHir6wqaajo6Uq5Ybqlb1a5Ybyyb5tRz8AoXSmpPVCTgaAt7fv\noXte4ZvRUCxFNFJDX+9Q0efyScZdhfP4y+7tYPHCdk77yP588JDZ1IRCDPaPMOjNPePYhTy5eju3\n//5VDu5sGrPhUibjsLtvhAPmjf+dFvrOL/2k4GQyPP3qTr5x05/5xgVHlRwwLxd+4D6EU/Da8lFq\n6uxDwLne63OB+4FngWNEpFVEmnGD1KuAB4HzvLln4Qaq08BaEVnijZ/jrfEIcIaIRERkPjBfVV/z\n1jg/53yGYZSJUkt9+LQVuTFveCQ5oUwogIVzWzhkvzaWfKCT6y/9CH934dF86NCOMfeJdM5sZOkH\n57GjZ5gn1uwYc709QwnSGYeZLRO7sUfCNfzNZw7jEx/Zn+27h/nOnc+zbVfpSrEcxBITqzgLASwL\nETka+D5u6mtSRD4PXATcISJfATYDd6hqWkSuBR7ATXu9XlUHROQe4DQRWYUbLP+St/TVwK1ettMz\nqvqwd77luEomA3zVm3szcJeIPAb0AheXfMWGYbyDUkt9+BRbpnw4lpqwsmioi/DfL/5w4PlnHX8g\nT76yg98+vpHjDp9LNLLvjdN/+i41E2o0NaEQFyw7hLamWn716Ab+6a7nueq8D3LwgvHdW5UinvTq\nQlUyG8rLWDpljI8+Mcbce4F7c8YywGVjzF0LnDjG+C3ALTljQ8DZhWQ1DKM0+ocShHA7vpXC3myo\nYFVgh2JJZrRMri9/Rksdp354P+5/ZgsPv7CV0z+6cJ/PJ5oJlUsoFOJTH1tEc2OUO1Yq//sXL/K3\nnzuCIw+eVfjgMuMH2yu6z8IwjHc/e4aTNDdGqakprtSHT1ODWyYkiGWRTGVIpjITtixK4YyPLaKh\nLsIfntr8js18fqmPcscXlh45n6+dcwSOAz/89WqeenVsN1gliSX9/tulf+emLAzDoH+otFIfPjWh\nEC2N0UDKwi9oNxXKorkhyqeOXcjgSJI/Prtln8/K6YbK5ahDZ/ONC46iLhpm+YrXeCDn3JVmr2VR\n+i3flIVhvMdJptKMxFMl77HwaW2qDdQtL6ssJvCUOxFOO2Z/WptqeeC5t/Ypq15uN1Qu79u/nWsv\nOpr25lp+8fB6fvXo+oL7PspFOWIWpiwM4z3OgBdnKLadai6tTbXEE+nsjSkfI4mpsyzAvWGeueQA\n4sk0f3hyU3a8pz9ONFJDc4lxmyDsN6eZ/37Jh5k7s5GVT2/h7ofWTYrCiGUtC3NDGYZRInsmmAnl\n41smAwVcUSPZXhalP+VOlJOOms/stnoeeXEru/rc0hw9A27ToyCFECfC7LYG/v6io9mvo4k/Pf82\nd/5Ry9qTYyziE2x8BKYsDOM9z0TTZn1am9wn8kKuqGGv2OBEighOlEi4hrOXHkQ64/CbxzeSSKYZ\nGE4yq0IuqFxam2q55osfYuGcZh59aRu3/+frFe2BEZuM1FnjvcdwLMnO3hG6ekfo6h0m48DSI+dN\n+S7U3oE4L6/fxYvrdrHu7T5CIYiGa4hG3IYu0Yj3L1xDxPt/UWcLR7+vg/3nNFf8iXE64jgOjsO4\nWU7ZIoKNE3O/BN1rMZUB7tEce9hcVj6zmade2cGHDu0AmPCGvGJoaazlm1/8EDfe8xKPr9lOOpPh\nsk+/f8zd5RMlPhmb8t6rOI7Dc6938erGHpoborQ21br/Gmuzr1saSk81nEpS6Qx7BhP0DsTp3jPC\nzp5huvp85TDC4Mg7c+V//+Qmjj9iHmcct4g5k1Sn33Ectu4a4sV1u3hpXTcbt+8tU9A5s5FopIZU\n2k3DjCXcJ0P/vf+M9vKG3fzuiU3Mbqvn6Pd1cPT7OjhkQVtV/tyKwXEcnnp1B798eD3JtIPs344s\nbGfxwhnsP6d5n+v3d29POGYRcBf3dFEWNTUhzjnpYG7+j9X8/EEFKhfczkdzQ5RvfuFD/OCXL/HU\nqztJZxz+5jOHldzNLh/ZbCizLMrLSDzFnX9Unn5t57jzQkBzY5S2plo62huYO6OROTMb6JzRyNyZ\njbQ31+Z9mo0n0uzsHWZHzzA7e9z/d/SMZIOD4ZqQ+y8cIlxTk30dqakhEg5RFw1TWxumLhqmPhqm\nNhqmrnbv69poDYMjSXoH4vT2x+kZiLmvB+L0DyUYy+AN14SY3d7AQfNbmdPewJwZDcyd2UjfYJz/\nfHoLj728jcdXb+fYw+by6eMWMX920wS/afemls44XlVMh3Q6w/bdw66CWN9Nd5+boVITCvH+RTM4\n6tDZfOiQ2eM2lvHXHImnWLu5lxfe6Gb1ht088NxbPPDcW7Q2RjnqUFdxvH/RjAlfw3Sju2+En/1R\neXVjD7XRGtqaanlp/S5eWr8LcN0/79u/ncUL25GFM+gbLI8bKmjl2ayyKLLXdyX44MGzOGRBG+u3\n7gEqkzZbiMb6CF+/4Chu+tXLPLu2i1Ta4aufPbysCsPcUOOwZUc/DeHinx43bNvDv/3uVbr7Yhw0\nv5ULP/4+Mo5D/1DC/TecGPU6Sf9Qgl17Yrzd/c7aL7XRGua0NzJ3ZgNz2hsYiadc5dA7Qu9AbtV3\n92bd0lRLKpUhncmQTrs3vXSZfJmRcA0zWmo5dP92ZrbUMaOljllt9a6Sm9HAzNa6vCbw8R+Yx1+0\nixVPbuKpV3fw9Ks7+PDiOXzmuEUsnDt28bHhWJLNOwfZvGOALTsH2LxzgKGRJKm0Q2rU9eWjrjbM\nMYvn8KFDZ3PkwbNoqg/mJgmFQkTCIVoaa/no++fy0ffPJZnKZBXHS+u6eezlbTz28jbqa8PIohmE\nQ64C9hVunaeI3f9raKiN0NbsfmetTdHAroJUOsPuPTG6+kbo9v7NaKnnhCM6s/0YykU6k+Ghv7zN\nfaveJJHM8IEDZ/JfThdmtzfQ0x9Dt/Tx+pZedEvfPsrDpxypswBdvSNkHCdvL2+/pPhUxix8QqEQ\nnz/5YL73c7e1zlS5WhvqInz9/KP4v//xMi+80c0t967hb88+YtyKvMlUhi07B9i0Y4CaELQ119HW\nXEtbUy1tTXX7HGtuqHH42v95hGNkDmcefwD7dTQXnJ9xHFY+vZnfrNpIJuPw6eMW8dkTDgyk3R3H\nYWA4yc7eYXb2jLj/947Q5SmGt7sH95k/q7WOww6YwdyZjVkrpHNmA7Pa6umc2/aOqpD+k7J7c3Wf\nwONJN0XRT1XM/u+/TmVobogyo6UuqxiaG6Il++1rakJ89P1zOWbxHF5et4sVT27iL6938ZfXu/jg\nwbP45LELeWv3CKvf2MnmHa5i8K0Cn/raMO3NdUTCIcJh10IKe5ZSJOxbTzW0NdZy5CGzWLyw9PLV\nuUQjNRx58CyOPHgWmdOF9Vv38MIb3bzwRjcvr9tVeIFRhELujXFGcx3tngJpb66lrbmO/qFEVil0\n943QMxBnrESX+x57k+OP6OTjx+xP58zGCV/flp0D3L7ydTbtGKC5IcpffXIxHztsbvbnPbO1nuM+\n0MlxH3BbwezeE0Pf6uX1LX28vrmXpvoobc0TUxZuJhE88coO9K0+lnygk+OPmEdHjhU4XdxQPu/b\nv50jD57Fmg27mTtz6lqh1tWGufK8D/Ivv17Nyxt288N7V/O1s4+gNhrGcRx274mxYVs/G7bt4c1t\n/WzZOUAqnf9hq6k+QrunQLbsHKQmxIT+nkKTtSlksrnqB486G952TctjpIMzjz+Q/eeMrTR6B+L8\n5PevsXZzL+3Ntfx/Zx5eNveE4zjsGUrQ1TtCY12EOTMaqB1Hu1dLuWzHcXh1Yw8rntzEOu97Hk1z\nQ5RFc5tZ2NnCorktLOpsoaO9Ie/T5lTS1t7I1u17iCfSxHIUcCyZIpHMMBxL0TcYp2/QdeW5/ydI\npTN5153RUkdHWz0d7Q10zGigo72B2W31rH97D3964e1seYkjD57FaR/Zn8MWzShambe2N3Lbb9Zw\n/zNbyDgOxx3eyRdOPWTKeihs2LaHP7+4jede78q6VGX/do4/Yh7HLO6gvjbCj+5bw1+0mx987Xja\nSmwyVG5G4im27RoKVOiv0n+jyVSaW+57hdUbdnPwglZaG2vZsK1/H/deuCbE/nOaOXh+GwfOb6Em\nFGLPUII9gwn6huLsGUx47+PZToILOpr49l8fW+ja8v4CvmuVheM4zkNPb+J3j29k0w73B3v0+zo4\n6/gD9nGbvLR+F7f9YS2DI0mOOmQ2l56xeEqblVSLshiNbunlqVd3MG9OCx0tdSya28LM1rqqyT4q\n9Tt3HIehWIq+gTi9g+4faEtjNKsUxnsoSGcyvPDGLh587q2sv3zB7CZO+8j+fOywueMem3HceMzG\n7f38vz+tZ/uuIWa31fNfPil84MDJL1I3FrFEiue1myfWbOf1LX2AW8TumMUdbNoxwNbuIf71GyeN\ne53Tlcn4G02mMvzrb1/hRc/qndlax0Hz2zh4fisHz29j4dzmwN9dMpVmz2CCAxbOZLB//Hav70ll\nATjd3QM4jsOaN3v43RMbeXOb2+DlqENmc8Zxi3jmtZ386fm3iYRruGDZISw7esGU3+CqUVn4VKvs\nUy33m9v6eegvb/Hc612kMw7NDVGOfl8HmYzDUCzJSDzFcCzFUCzFcDxFLJ7KJijUhODjx+zP2UsP\nmlDwspJ0943w5Cs7eGLNdnbtcV2TkXCIW7958pT/vZXCZP2+pDMZNu8YZIbnRp4oQeR+TyuL7BvP\nbfLbJzayYWt/dnz+7Ca+ctbheV1Uk81U37gmQrXKPl3k7h2I88iLb/Poi9vekb5cXxumsT5CY12U\nxvoITfURmhuinL3sUNqnQVZREDKOw7q3+njylR0snN/GqUflb286nZkuvy/F8p5RFiJyI/Ax3KZI\nV6nqXwoc4oz1xTiOw2ube/njM1vonNnIuScfPKEa7+WmWn8RoXpln25yJ5Jptu8epr4uTFN9lIa6\ncN7sq+kme1CqVW6oXtknqiyq4pFERE4EDlHVJSKyGLgNt21r0YRCIQ4/YCaHHzCzrDIaRrmojYZZ\n1Fm4j7VhTCbVUhvqVOA3AKr6OtDu9fk2DMMwJoFqURadQPeo97u8McMwDGMSqBZlkUv1pVAYhmFU\nMVURswC2sa8lMR/YXuCYUEdHdfp9q1VuqF7Zq1VuqF7Zq1VuqF7ZJyJ3tVgWDwCfBxCRo4GtqvrO\nYkyGYRhGRaim1NnvAicBaeByVV0zxSIZhmG8Z6gaZWEYhmFMHdXihjIMwzCmEFMWhmEYRkFMWRiG\nYRgFqZbU2TERkQ/g7uy+UVV/NM68duD/AQOqev5kyTeGHBOWV0TmAmuBz6nqY5WUd9Q5S5ZbRBqB\nO4C5wCDwJVXtqrzUWZmCyn4B8HXcBIqHVfV/iMg83NIydbgPVler6ouTIHaubAWvwcsS/D7g4O5D\nOgz4rKo+PYlyNgC34/6s64D/pap/yDN3rN+VvwK+Daz3pj2oqv9Uablz5CrmGq4DPum9/YOqfmdS\nhCyAiNQDrwA3qOrP8swp+p5YtZaFdxO6GXgowPR/BVZVVqLxKaO8/wxsKJdchSiD3F8G1qvqicB3\ncG8Gk0JQ2b0bxD8Bp6jqEuDjXg2yrwP3quoy4O+B71ZY5LFkC3QNqvqCqp7iyfo54LXJVBQeZwLP\nqdmtih4AAAXRSURBVOrJwAXAjePMzfc7/gtVXeb9m1RF4RHoGkRkEXC49/tyAvBXIjJdqkp8C9hd\nYE7R98SqVRZADPgUhTfnAfw18ERlxSnIhOUVkVOAfmAy04YnKvehwLMAqvoE7h/WZBFIdlUdAY5Q\n1WFvaDcwC7fEjN9NaCb7lpyZLIr5/n2+CdxUGXHyo6q/VNX/471dCLw1zvTp8Df5DoJeg6puVtUL\nvLczcS3S/rHmTiYiIsBiYExraBRFf/9VqyxUNaOq8YBzp3wD30TlFZEocB3wD0xiuZMyfM9rgDMA\nROQk3D/ASaEU2UXkCGAR8DTuDfcLIrIWuBX3+59UirkGyLogPqGqv62gWIVkeAK4C7gq35xx/iZP\nFpH/FJEHReSoiggYgCDX4M27Cfd3/NujHjamku/jWsTj3iNKuSdWrbJ4D3ItsFxV/aeXaqmP9VMg\nISKPAR8HJi1eUSwicijwc+CLqpoGrgHuUdX347rTvj+V8gXkcxR+qqwoqno88Fnc77IYngL+UVXP\nwHWljOlvnwyCXoOqXoX7JP93nmtqyhCRS4AnVXWzN1TWe4Qpi+rhdOBrIvIU8GngFhF5/xTLVBBV\nTarq5V7M4nvAlFt5YyEi+wH3ApeMqg5wPHC/9/oh4JipkK1IPkOw+FLZEZGjve8RVX0ZiIjI7KDH\nq+obqrrSe/00MFtEJvWhKOg1iMh+IvJhb94eXJfORyZT1jH4NPBZ7x7xN8D/EJFl5Vq8qrOhRhHk\nFyoUcN5kULS8qpr19YvIvwP/rqprKyBbIZmCzMnOE5FPAcep6nXAJcDKCskWRK7x+AnwX70bhM86\n3O6MLwIfBd6okGxBCfL9fwR4ueCsynAirgvvai9rr0lVd40zP/d35RrgLVX9hZcB1q2qk11iIug1\ndAA/FpGP4V7Dh3FdlVOGqn7Bfy0i/whsVNWHxzmkqHti1Zb7GJUquAhIAluBc1S1L2deDfAnoA1Y\nALyKm1L2aLXKKyK3AbdPRursROXG9f3/B26geDeui2dSelIWIfuhuArhWdw/Hgc3C+Y53NTZxv+/\nvfsJsSmOAjj+1SxMStaS1aiTJDsiQsyGEguFvZIyFpLIwkJJEsqfldUIG7OSkiIlsZEF6mRhLNRs\nyJaExe9OM3hv7txnvPH4furVe/fd2zu/et3zfvf97jnVtqHMfNGN2CfFNq0xTNp/LDNnZVVO9X/J\nVWAx0A+cyMw7LfZr9115DQxTrnj0UZYq17VPnlHTHUO17xFgR/Xydmae7E6U9SYli18u5XV6TuzZ\nZCFJ6p5/5TIUEbEX2EP5BQgTvxCPZubTWQusjV6Ld1yvxg29Hfu4XhpDL8XaTi+PYaZjd2YhSarl\naihJUi2ThSSplslCklTLZCFJqmWykP6QiFhYFX/s5NgVEXGhxfaBiHjz+9FJzfwzS2elv9BGYCnw\noOmB1Z3kB9u87RJGdZ3JQmooIo4D2yhlqa8Bz4HTlHLi84D9wEdK/w4i4j1wqXoMAPOBG5l5borP\nWE9pvLMuItYAVyhFGJ/9oWFJU/IylNRARKwFtmTmSmAdMEgpZbIvMzdTGhUdy8xRSse14cw8T5kl\nvMvMTZR6U7ur+kdTGZ9BnAEOZ+YgMDbDQ5KmxZmF1Mwqqg5jmfkF2B4Rq4CzVV2hBcCHFsdtBBZF\nxIbq9VxgCaX9ZZ3lTDSquQ8c6Dh6qUMmC6mZb/w6Ix8G9mbmw4jYChxqcdwnSrG2kQ4+cw7wtXre\n18Hx0m8zWUjNPAYuR0QfJWnco1SEfVVt20mZNUA5wfdXzx9RejqPVFU/z1C6q7WsHvuTl8Bqyqxi\ncKYGIjVhspAayMwnEXGLcvIHuA7cpax4GqUkgeGIGKJcrroZEZ8pf3Yvi4jHlCRze5qJAuAIcDEi\n3lJKqUtdZyFBSVItZxbSLKm6rJ3ix/smxstI78rMv7Zfuf4/ziwkSbW8z0KSVMtkIUmqZbKQJNUy\nWUiSapksJEm1TBaSpFrfAUwtBDhHWrBCAAAAAElFTkSuQmCC\n"
     },
     "output_type": "display_data",
     "metadata": {}
    }
   ],
   "source": [
    "m_data['timediff'] = m_data.timestamp_x - m_data.timestamp_y\n",
    "(m_data[['timediff']].groupby(m_data.cate_id).sum() / m_data[['timediff']].groupby(m_data.cate_id).count()).plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_news.index = all_news.date\n",
    "all_news = all_news.sort_index()\n",
    "news.index = news.date\n",
    "\n",
    "news = news.sort_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>item_id</th>\n",
       "      <th>cate_id</th>\n",
       "      <th>action_type</th>\n",
       "      <th>timestamp_x</th>\n",
       "      <th>view</th>\n",
       "      <th>deep_view</th>\n",
       "      <th>collect</th>\n",
       "      <th>share</th>\n",
       "      <th>comment</th>\n",
       "      <th>timestamp_y</th>\n",
       "      <th>date</th>\n",
       "      <th>timediff</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>action_time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>11482147</td>\n",
       "      <td>492681</td>\n",
       "      <td>1_11</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174400</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486731016</td>\n",
       "      <td>2017-02-10 20:50:16</td>\n",
       "      <td>443384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>12070750</td>\n",
       "      <td>457406</td>\n",
       "      <td>1_14</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174400</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486257499</td>\n",
       "      <td>2017-02-05 09:18:19</td>\n",
       "      <td>916901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>12431632</td>\n",
       "      <td>527476</td>\n",
       "      <td>1_1</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174400</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487002729</td>\n",
       "      <td>2017-02-14 00:18:49</td>\n",
       "      <td>171671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>13397746</td>\n",
       "      <td>531771</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174400</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487050334</td>\n",
       "      <td>2017-02-14 13:32:14</td>\n",
       "      <td>124066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>13794253</td>\n",
       "      <td>510089</td>\n",
       "      <td>1_27</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174400</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486876954</td>\n",
       "      <td>2017-02-12 13:22:34</td>\n",
       "      <td>297446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>14378544</td>\n",
       "      <td>535335</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174400</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487079269</td>\n",
       "      <td>2017-02-14 21:34:29</td>\n",
       "      <td>95131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>1705634</td>\n",
       "      <td>535202</td>\n",
       "      <td>1_10</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174400</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487077912</td>\n",
       "      <td>2017-02-14 21:11:52</td>\n",
       "      <td>96488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:00</th>\n",
       "      <td>6943823</td>\n",
       "      <td>478183</td>\n",
       "      <td>1_3</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174400</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486530387</td>\n",
       "      <td>2017-02-08 13:06:27</td>\n",
       "      <td>644013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:01</th>\n",
       "      <td>5902475</td>\n",
       "      <td>524378</td>\n",
       "      <td>1_6</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174401</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486981875</td>\n",
       "      <td>2017-02-13 18:31:15</td>\n",
       "      <td>192526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:02</th>\n",
       "      <td>12646404</td>\n",
       "      <td>529724</td>\n",
       "      <td>1_3</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174402</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487037671</td>\n",
       "      <td>2017-02-14 10:01:11</td>\n",
       "      <td>136731</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:02</th>\n",
       "      <td>13156768</td>\n",
       "      <td>426867</td>\n",
       "      <td>1_17</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174402</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486530062</td>\n",
       "      <td>2017-02-08 13:01:02</td>\n",
       "      <td>644340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:02</th>\n",
       "      <td>14367772</td>\n",
       "      <td>484321</td>\n",
       "      <td>1_3</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174402</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486627665</td>\n",
       "      <td>2017-02-09 16:07:45</td>\n",
       "      <td>546737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:02</th>\n",
       "      <td>15967218</td>\n",
       "      <td>468533</td>\n",
       "      <td>1_3</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174402</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486371039</td>\n",
       "      <td>2017-02-06 16:50:39</td>\n",
       "      <td>803363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:02</th>\n",
       "      <td>7500423</td>\n",
       "      <td>531150</td>\n",
       "      <td>1_9</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174402</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487047860</td>\n",
       "      <td>2017-02-14 12:51:00</td>\n",
       "      <td>126542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>11227572</td>\n",
       "      <td>522855</td>\n",
       "      <td>1_17</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486972198</td>\n",
       "      <td>2017-02-13 15:49:58</td>\n",
       "      <td>202205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>12431632</td>\n",
       "      <td>534450</td>\n",
       "      <td>1_1</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487071143</td>\n",
       "      <td>2017-02-14 19:19:03</td>\n",
       "      <td>103260</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>12799141</td>\n",
       "      <td>531289</td>\n",
       "      <td>1_1</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487048296</td>\n",
       "      <td>2017-02-14 12:58:16</td>\n",
       "      <td>126107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>14380477</td>\n",
       "      <td>535477</td>\n",
       "      <td>1_1</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487080812</td>\n",
       "      <td>2017-02-14 22:00:12</td>\n",
       "      <td>93591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>15894951</td>\n",
       "      <td>491934</td>\n",
       "      <td>1_23</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486725697</td>\n",
       "      <td>2017-02-10 19:21:37</td>\n",
       "      <td>448706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>15905528</td>\n",
       "      <td>432274</td>\n",
       "      <td>1_2</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486076461</td>\n",
       "      <td>2017-02-03 07:01:01</td>\n",
       "      <td>1097942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>1904514</td>\n",
       "      <td>530486</td>\n",
       "      <td>1_13</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487042049</td>\n",
       "      <td>2017-02-14 11:14:09</td>\n",
       "      <td>132354</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>2415271</td>\n",
       "      <td>535363</td>\n",
       "      <td>1_6</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487079704</td>\n",
       "      <td>2017-02-14 21:41:44</td>\n",
       "      <td>94699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>2472319</td>\n",
       "      <td>535334</td>\n",
       "      <td>1_23</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487079238</td>\n",
       "      <td>2017-02-14 21:33:58</td>\n",
       "      <td>95165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>6088961</td>\n",
       "      <td>533833</td>\n",
       "      <td>1_1</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487065826</td>\n",
       "      <td>2017-02-14 17:50:26</td>\n",
       "      <td>108577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:03</th>\n",
       "      <td>8350505</td>\n",
       "      <td>527149</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174403</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486996151</td>\n",
       "      <td>2017-02-13 22:29:11</td>\n",
       "      <td>178252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:04</th>\n",
       "      <td>11996914</td>\n",
       "      <td>530796</td>\n",
       "      <td>1_14</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174404</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487044185</td>\n",
       "      <td>2017-02-14 11:49:45</td>\n",
       "      <td>130219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:04</th>\n",
       "      <td>14378544</td>\n",
       "      <td>515907</td>\n",
       "      <td>1_6</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174404</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486911191</td>\n",
       "      <td>2017-02-12 22:53:11</td>\n",
       "      <td>263213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:04</th>\n",
       "      <td>16401821</td>\n",
       "      <td>535084</td>\n",
       "      <td>1_23</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174404</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487077024</td>\n",
       "      <td>2017-02-14 20:57:04</td>\n",
       "      <td>97380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:04</th>\n",
       "      <td>7908369</td>\n",
       "      <td>503571</td>\n",
       "      <td>1_23</td>\n",
       "      <td>view</td>\n",
       "      <td>1487174404</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486817643</td>\n",
       "      <td>2017-02-11 20:54:03</td>\n",
       "      <td>356761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-16 00:00:04</th>\n",
       "      <td>8462794</td>\n",
       "      <td>500412</td>\n",
       "      <td>1_12</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487174404</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486803293</td>\n",
       "      <td>2017-02-11 16:54:53</td>\n",
       "      <td>371111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:55</th>\n",
       "      <td>14503435</td>\n",
       "      <td>556944</td>\n",
       "      <td>1_11</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433595</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487335792</td>\n",
       "      <td>2017-02-17 20:49:52</td>\n",
       "      <td>97803</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:55</th>\n",
       "      <td>14785354</td>\n",
       "      <td>557391</td>\n",
       "      <td>1_13</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433595</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487338542</td>\n",
       "      <td>2017-02-17 21:35:42</td>\n",
       "      <td>95053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:55</th>\n",
       "      <td>6046417</td>\n",
       "      <td>549425</td>\n",
       "      <td>1_3</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433595</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487249264</td>\n",
       "      <td>2017-02-16 20:47:44</td>\n",
       "      <td>184331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:55</th>\n",
       "      <td>7994897</td>\n",
       "      <td>542900</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433595</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487168917</td>\n",
       "      <td>2017-02-15 22:28:37</td>\n",
       "      <td>264678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:55</th>\n",
       "      <td>8046141</td>\n",
       "      <td>548638</td>\n",
       "      <td>1_3</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433595</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487242113</td>\n",
       "      <td>2017-02-16 18:48:33</td>\n",
       "      <td>191482</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>13642170</td>\n",
       "      <td>557656</td>\n",
       "      <td>1_12</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433596</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487339745</td>\n",
       "      <td>2017-02-17 21:55:45</td>\n",
       "      <td>93851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>14597382</td>\n",
       "      <td>529781</td>\n",
       "      <td>3_2</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433596</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487037905</td>\n",
       "      <td>2017-02-14 10:05:05</td>\n",
       "      <td>395691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>15123124</td>\n",
       "      <td>542966</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433596</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487169140</td>\n",
       "      <td>2017-02-15 22:32:20</td>\n",
       "      <td>264456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>1552565</td>\n",
       "      <td>540172</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433596</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487174520</td>\n",
       "      <td>2017-02-16 00:02:00</td>\n",
       "      <td>259076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>16801260</td>\n",
       "      <td>557673</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433596</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487339814</td>\n",
       "      <td>2017-02-17 21:56:54</td>\n",
       "      <td>93782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:56</th>\n",
       "      <td>9526597</td>\n",
       "      <td>556855</td>\n",
       "      <td>1_1</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433596</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487335204</td>\n",
       "      <td>2017-02-17 20:40:04</td>\n",
       "      <td>98392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>13050562</td>\n",
       "      <td>522664</td>\n",
       "      <td>3_2</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433597</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486971172</td>\n",
       "      <td>2017-02-13 15:32:52</td>\n",
       "      <td>462425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>13375001</td>\n",
       "      <td>542997</td>\n",
       "      <td>1_3</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433597</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487169285</td>\n",
       "      <td>2017-02-15 22:34:45</td>\n",
       "      <td>264312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>14597382</td>\n",
       "      <td>524113</td>\n",
       "      <td>3_2</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433597</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486979325</td>\n",
       "      <td>2017-02-13 17:48:45</td>\n",
       "      <td>454272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>15488166</td>\n",
       "      <td>555820</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433597</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487404440</td>\n",
       "      <td>2017-02-18 15:54:00</td>\n",
       "      <td>29157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>16243453</td>\n",
       "      <td>557432</td>\n",
       "      <td>1_23</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433597</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487338683</td>\n",
       "      <td>2017-02-17 21:38:03</td>\n",
       "      <td>94914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>16487497</td>\n",
       "      <td>545043</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433597</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487214631</td>\n",
       "      <td>2017-02-16 11:10:31</td>\n",
       "      <td>218966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:57</th>\n",
       "      <td>17026753</td>\n",
       "      <td>543007</td>\n",
       "      <td>1_1</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433597</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487169334</td>\n",
       "      <td>2017-02-15 22:35:34</td>\n",
       "      <td>264263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:58</th>\n",
       "      <td>11283320</td>\n",
       "      <td>553331</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433598</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487310115</td>\n",
       "      <td>2017-02-17 13:41:55</td>\n",
       "      <td>123483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:58</th>\n",
       "      <td>12982345</td>\n",
       "      <td>514928</td>\n",
       "      <td>1_6</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433598</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486905607</td>\n",
       "      <td>2017-02-12 21:20:07</td>\n",
       "      <td>527991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:58</th>\n",
       "      <td>1469607</td>\n",
       "      <td>555989</td>\n",
       "      <td>1_6</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433598</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487328445</td>\n",
       "      <td>2017-02-17 18:47:25</td>\n",
       "      <td>105153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:58</th>\n",
       "      <td>3063774</td>\n",
       "      <td>557764</td>\n",
       "      <td>1_2</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433598</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487340401</td>\n",
       "      <td>2017-02-17 22:06:41</td>\n",
       "      <td>93197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:58</th>\n",
       "      <td>9121520</td>\n",
       "      <td>552734</td>\n",
       "      <td>1_1</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433598</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487303894</td>\n",
       "      <td>2017-02-17 11:58:14</td>\n",
       "      <td>129704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>10383492</td>\n",
       "      <td>536548</td>\n",
       "      <td>1_1</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433599</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487100868</td>\n",
       "      <td>2017-02-15 03:34:28</td>\n",
       "      <td>332731</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>13006837</td>\n",
       "      <td>552829</td>\n",
       "      <td>1_9</td>\n",
       "      <td>deep_view</td>\n",
       "      <td>1487433599</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487305588</td>\n",
       "      <td>2017-02-17 12:26:28</td>\n",
       "      <td>128011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>13992209</td>\n",
       "      <td>548120</td>\n",
       "      <td>1_11</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433599</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487237208</td>\n",
       "      <td>2017-02-16 17:26:48</td>\n",
       "      <td>196391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>14597382</td>\n",
       "      <td>453373</td>\n",
       "      <td>3_2</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433599</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486180676</td>\n",
       "      <td>2017-02-04 11:57:56</td>\n",
       "      <td>1252923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>16699556</td>\n",
       "      <td>523378</td>\n",
       "      <td>3_6</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433599</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1486974406</td>\n",
       "      <td>2017-02-13 16:26:46</td>\n",
       "      <td>459193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>4496330</td>\n",
       "      <td>557706</td>\n",
       "      <td>1_6</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433599</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487340046</td>\n",
       "      <td>2017-02-17 22:00:46</td>\n",
       "      <td>93553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-18 23:59:59</th>\n",
       "      <td>9391042</td>\n",
       "      <td>555820</td>\n",
       "      <td>1_6</td>\n",
       "      <td>view</td>\n",
       "      <td>1487433599</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1487404440</td>\n",
       "      <td>2017-02-18 15:54:00</td>\n",
       "      <td>29159</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3272043 rows × 13 columns</p>\n",
       "</div>"
      ]
     },
     "output_type": "execute_result",
     "metadata": {}
    }
   ],
   "source": [
    "# 聚类\n",
    "m_data[['user_id','cate_id','view','deep_view','collect','share','comment']].groupby(['user_id','cate_id']).sum()\n",
    "# m_data['score'] = m_data.view * 1 + m_data.deep_view * 2 + m_data.comment * 3 + m_data.collect * 4 + m_data.share * 5\n",
    "m_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>view</th>\n",
       "      <th>deep_view</th>\n",
       "      <th>collect</th>\n",
       "      <th>share</th>\n",
       "      <th>comment</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th>cate_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">0365F7AE-5048-42B3-BB2C-8E637A380A3E</th>\n",
       "      <th>1_1</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_10</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_16</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_2</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_3</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_9</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">06068254-792D-4AFE-AC6C-DE43DB15D735</th>\n",
       "      <th>1_3</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">077F63F3-3DF4-4041-B3C9-7BAB2BDCA795</th>\n",
       "      <th>1_1</th>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_3</th>\n",
       "      <td>22</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_6</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_9</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>08f6ea6d2181b902d8cbeccdccf61efc</th>\n",
       "      <th>1_5</th>\n",
       "      <td>24</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>095A18FB-2C8E-4C00-8F2D-B481CB674ECE</th>\n",
       "      <th>1_1</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">096F9140-F748-4DE3-A4C3-EBAAA277144D</th>\n",
       "      <th>1_1</th>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_10</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_18</th>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_5</th>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_9</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3_6</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3_7</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">0B9DDF98-12A0-45DF-9CF7-F4194BF23282</th>\n",
       "      <th>1_1</th>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_10</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_12</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_18</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_3</th>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_9</th>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3_1</th>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0F3D4D6F-A906-4396-BA3B-1E69B0F6867C</th>\n",
       "      <th>1_1</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">adcb95bf041f28650217e44295642069</th>\n",
       "      <th>1_5</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_6</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>afc516c182022de1d5b97eab0e1ded2d</th>\n",
       "      <th>1_9</th>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b1ad0229ae7e6e6fbf60d765a33f4224</th>\n",
       "      <th>1_5</th>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b229aecf4d60e1d41c53cf76f81b6328</th>\n",
       "      <th>1_6</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">b33521106f7043abb602fd6d979335d8</th>\n",
       "      <th>1_1</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_10</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_2</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">bd7652ef91f0e4c6dc4dbb0fa69b39af</th>\n",
       "      <th>1_17</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_5</th>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">c28593c24c1b3f0deb277588562a6d53</th>\n",
       "      <th>1_17</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_4</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"9\" valign=\"top\">c409b185f157669cac8de101eb3ba929</th>\n",
       "      <th>1_1</th>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_11</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_12</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_17</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_3</th>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_5</th>\n",
       "      <td>23</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_6</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_9</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>d47465895418527101d0ca0a44586763</th>\n",
       "      <th>1_15</th>\n",
       "      <td>28</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">ef443bb4e64d4a93a3babb83fb07cf04</th>\n",
       "      <th>1_1</th>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_10</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_11</th>\n",
       "      <td>58</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_12</th>\n",
       "      <td>18</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_7</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">f69fb63a3673456c9713bff4af597e95</th>\n",
       "      <th>1_14</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>208598 rows × 6 columns</p>\n",
       "</div>"
      ]
     },
     "output_type": "execute_result",
     "metadata": {}
    }
   ],
   "source": [
    "m_data['score'] = m_data.view * 1 + m_data.deep_view * 2 + m_data.comment * 3 + m_data.collect * 4 + m_data.share * 5\n",
    "# m_data[['user_id','item_id','cate_id', 'view', 'deep_view','collect', 'share', 'comment', 'score']].groupby(m_data[['user_id','cate_id']]).sum()\n",
    "g_data = m_data[['user_id','cate_id','view','deep_view','collect','share','comment','score']].groupby(['user_id','cate_id']).sum()\n",
    "g_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_pickle(path):\n",
    "    input = open(path, 'rb')\n",
    "    data = pickle.load(input)\n",
    "    return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "28501\n"
     ]
    }
   ],
   "source": [
    "cdt = get_pickle('../pkl/list.candidate.pkl')\n",
    "print(len(cdt))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>view</th>\n",
       "      <th>deep_view</th>\n",
       "      <th>collect</th>\n",
       "      <th>share</th>\n",
       "      <th>comment</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th>cate_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">0365F7AE-5048-42B3-BB2C-8E637A380A3E</th>\n",
       "      <th>1_1</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_10</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_16</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_2</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_3</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_9</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">06068254-792D-4AFE-AC6C-DE43DB15D735</th>\n",
       "      <th>1_3</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">077F63F3-3DF4-4041-B3C9-7BAB2BDCA795</th>\n",
       "      <th>1_1</th>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_3</th>\n",
       "      <td>22</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_6</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_9</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>08f6ea6d2181b902d8cbeccdccf61efc</th>\n",
       "      <th>1_5</th>\n",
       "      <td>24</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>095A18FB-2C8E-4C00-8F2D-B481CB674ECE</th>\n",
       "      <th>1_1</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">096F9140-F748-4DE3-A4C3-EBAAA277144D</th>\n",
       "      <th>1_1</th>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_10</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_18</th>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_5</th>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_9</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3_6</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3_7</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"8\" valign=\"top\">0B9DDF98-12A0-45DF-9CF7-F4194BF23282</th>\n",
       "      <th>1_1</th>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_10</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_12</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_18</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_3</th>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_9</th>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3_1</th>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0F3D4D6F-A906-4396-BA3B-1E69B0F6867C</th>\n",
       "      <th>1_1</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">adcb95bf041f28650217e44295642069</th>\n",
       "      <th>1_5</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_6</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>afc516c182022de1d5b97eab0e1ded2d</th>\n",
       "      <th>1_9</th>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b1ad0229ae7e6e6fbf60d765a33f4224</th>\n",
       "      <th>1_5</th>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b229aecf4d60e1d41c53cf76f81b6328</th>\n",
       "      <th>1_6</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">b33521106f7043abb602fd6d979335d8</th>\n",
       "      <th>1_1</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_10</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_2</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">bd7652ef91f0e4c6dc4dbb0fa69b39af</th>\n",
       "      <th>1_17</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_5</th>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">c28593c24c1b3f0deb277588562a6d53</th>\n",
       "      <th>1_17</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_4</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"9\" valign=\"top\">c409b185f157669cac8de101eb3ba929</th>\n",
       "      <th>1_1</th>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_11</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_12</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_17</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_3</th>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_5</th>\n",
       "      <td>23</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_6</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_9</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>d47465895418527101d0ca0a44586763</th>\n",
       "      <th>1_15</th>\n",
       "      <td>28</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"6\" valign=\"top\">ef443bb4e64d4a93a3babb83fb07cf04</th>\n",
       "      <th>1_1</th>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_10</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_11</th>\n",
       "      <td>58</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_12</th>\n",
       "      <td>18</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_7</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">f69fb63a3673456c9713bff4af597e95</th>\n",
       "      <th>1_14</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>208598 rows × 6 columns</p>\n",
       "</div>"
      ]
     },
     "output_type": "execute_result",
     "metadata": {}
    }
   ],
   "source": [
    "gt_data = g_data.loc[cdt]\n",
    "# gt_data.loc['ef443bb4e64d4a93a3babb83fb07cf04'].sort_values('score')\n",
    "gt_data.to_pickle('../pkl/baseline.pkl')\n",
    "gt_data"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3.0
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}